Parameters Provided:
name.synonym = 17,23beta-Epoxy-3beta-hydroxyveratraman-11-one; BRN 0059109; EINECS 207-417-9; HSDB 3502; Iervin; Jervine; Jerwiny [Polish]; LS-145833; NSC 23898; NSC 7520; Spiro(9H-benzo(a)fluorene-9,2'(3'H)-furo(3,2-b)-pyridin)-11(1H)-one, 2,3,3'a,4,4',5',6,6',6a,6b,7,
filter.purchasability = all
page.num = 1
Structural Results Found: (before additional filtering)
SQL Query Was
SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE '17,23beta-Epoxy-3beta-hydroxyveratraman-11-one; BRN 0059109; EINECS 207-417-9; HSDB 3502; Iervin; Jervine; Jerwiny [Polish]; LS-145833; NSC 23898; NSC 7520; Spiro(9H-benzo(a)fluorene-9,2\'(3\'H)-furo(3,2-b)-pyridin)-11(1H)-one, 2,3,3\'a,4,4\',5\',6,6\',6a,6b,7,' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id WHERE c.free = 1 ) LIMIT 50
Permalink
//zinc12.docking.org/results/combination?name.synonym=17%2C23beta-Epoxy-3beta-hydroxyveratraman-11-one%3B+BRN+0059109%3B+EINECS+207-417-9%3B+HSDB+3502%3B+Iervin%3B+Jervine%3B+Jerwiny+%5BPolish%5D%3B+LS-145833%3B+NSC+23898%3B+NSC+7520%3B+Spiro%289H-benzo%28a%29fluorene-9%2C2%27%283%27H%29-furo%283%2C2-b%29-pyridin%29-11%281H%29-one%2C+2%2C3%2C3%27a%2C4%2C4%27%2C5%27%2C6%2C6%27%2C6a%2C6b%2C7%2C&filter.purchasability=all
Embed Link to Results
